Stored Procedures [dbo].[BAEEventAddRegistrantAnswer]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventAddRegistrantAnswer
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@eventCodevarchar(15)15
@registrantIDvarchar(10)10
@questionIDint4
@answervarchar(512)512
SQL Script
CREATE procedure [dbo].[BAEEventAddRegistrantAnswer] @eventCode varchar(15),
     @registrantID varchar(10),
     @questionID int,
     @answer varchar(512) as
DELETE FROM EventRegistrationAnswer
    WHERE EventCode = @eventCode AND RegistrantID = @registrantID AND QuestionID = @questionID;
    
    INSERT INTO EventRegistrationAnswer (EventCode, RegistrantID, QuestionID, Answer)
    VALUES (@eventCode, @registrantID, @questionID, @answer);

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved